package test.top1.com.atguigu.utils;

/**
 * ClassName: MySqlUtil
 * Package: test.top1.com.atguigu.utils
 * Description:
 *
 * @Author ChenJun(有志男青年)
 * @Create 2023/5/4 10:05
 * @Version 1.0
 */
public class MySqlUtil {
    public static String getMysqlBaseDicDDL(){
        return "CREATE TABLE base_dic (\n" +
                "  dic_code string,\n" +
                "  dic_name STRING,\n" +
                "  parent_code STRIN,\n" +
                "  PRIMARY KEY (dic_code) NOT ENFORCED\n" +
                ") WITH (\n" +
                "   'connector' = 'jdbc',\n" +
                "   'url' = 'jdbc:mysql://hadoop102:3306/gmall',\n" +
                "   'table-name' = 'base_dic',\n" +
                "   'username'='root',\n" +
                "   'password'='000000'\n" +
                ")";
    }
}
